UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '05qrxL9ckfcW41vVlDe6j3V8MJQm2kaG8omOM81A9VY='
WHERE
key_id = 'a4a15ba12c362aa9ba41e3975dc3e9b2b740ffe9fcbd5655f279f2f9bd0335c2'
AND (
token = '05qrxL9ckfcW41vVlDe6j3V8MJQm2kaG8omOM81A9VY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)