UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bc0AvgZzplHH4JB5mQrzRhbF8ZDbW/eR8j4hg+Y036A='
WHERE
key_id = 'bc3c0a83c6b4f1b490cced265137a7972c142ab79174f8a7b2dc080b76b16ce2'
AND (
token = 'bc0AvgZzplHH4JB5mQrzRhbF8ZDbW/eR8j4hg+Y036A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)