UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oXg2nYPn0Bks1y2CT91lzQWkm0qRNLk92nc/ceEG7cU='
WHERE
key_id = '1be471274a715fe885378c6f3577f4b44b32e6accc9ea49062b90704726e969e'
AND (
token = 'oXg2nYPn0Bks1y2CT91lzQWkm0qRNLk92nc/ceEG7cU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)