UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ss7g1+o+zUbPMLN6I6vB39pjcN/ZRLeimJ9gApcO4Gg='
WHERE
key_id = 'ca1d461140b30c59463bcc5bea79330a7b96bb37f5dbeb195819a3c62d35d842'
AND (
token = 'ss7g1+o+zUbPMLN6I6vB39pjcN/ZRLeimJ9gApcO4Gg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)