UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bFk9wQtU5wY8xtKhUakb2Cx/m2eVErnsLtOKVGipU7o='
WHERE
key_id = 'ec4b91c2697a6a26d47cdfaf3ee03c43d549eec3d9ad8e55c1e2291db35913e7'
AND (
token = 'bFk9wQtU5wY8xtKhUakb2Cx/m2eVErnsLtOKVGipU7o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)