UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm2GAsPonstjy3tnZDnFvcTg2fYiWdJHdMJIj429vKDs='
WHERE
key_id = 'f4553ca18a1e174b921e04ad0f811ceec719c514487d07f4d47c1c0feb7578e3'
AND (
token = 'm2GAsPonstjy3tnZDnFvcTg2fYiWdJHdMJIj429vKDs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)