UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x8OKYyejEfkFlT8WmPj9xkhCwnf+CRAgTuUri69mWOI='
WHERE
key_id = '892a2e5b5b432ef16fa3a71672f7b7a48331de7456daf3cc42cef1b709ebc843'
AND (
token = 'x8OKYyejEfkFlT8WmPj9xkhCwnf+CRAgTuUri69mWOI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)