UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HXV2nJdD2DNvcos3pusKQQMNWEEsDa0JVWBN587mgWw='
WHERE
key_id = '6d072c042182abb1e3c74cdf4a91dac903e15a54bd27c6babd9d3e6564e1bc37'
AND (
token = 'HXV2nJdD2DNvcos3pusKQQMNWEEsDa0JVWBN587mgWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)