UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HFfcYouTkKHBJ6HTXrF3aQdutgE29JLd8/5YldAQYq8='
WHERE
key_id = '12c72e0dcf9abbad97e63799d9f76c343a5c305a77c25fe1e66c495a2b37a606'
AND (
token = 'HFfcYouTkKHBJ6HTXrF3aQdutgE29JLd8/5YldAQYq8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)