UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qgofGhFZ8knEs68qjvmb/A4AwAS7xBmV18cfOi7ZWTU='
WHERE
key_id = 'b5cba24138f707b9898c89d777f213df5f1eac0b1242fbb7d8af68613cabcc94'
AND (
token = 'qgofGhFZ8knEs68qjvmb/A4AwAS7xBmV18cfOi7ZWTU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)