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