UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OCgf7lUK8p+Myj7oe+pIbn01T1coRfBz6fXsrAOArMQ='
WHERE
key_id = 'ca678efeac3b9c6e1ed25233cc805003808931d8612982062a82dc1a3d010672'
AND (
token = 'OCgf7lUK8p+Myj7oe+pIbn01T1coRfBz6fXsrAOArMQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)