UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MM8ShPqY8DdQOAGq0DixuJdEWtzdCy7vF439m4/LphA='
WHERE
key_id = 'a650f50f4ce03574ac23d37d13a4503e7e3a1cb9420eca5bcdcae17c23fbf215'
AND (
token = 'MM8ShPqY8DdQOAGq0DixuJdEWtzdCy7vF439m4/LphA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)