UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zhaSN0YMsY0E8tblwItyUR9berxp+ZVj/Fcu7nTF3l4='
WHERE
key_id = '1a29057a29f20b1f4a73868d44a31b1cf10e9b4a0586294a2478becd76d9b0ad'
AND (
token = 'zhaSN0YMsY0E8tblwItyUR9berxp+ZVj/Fcu7nTF3l4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)