UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jZmJWBbfcqL/t5uUA1r6hTYmu6ceYcuD5+yDO3OS9m0='
WHERE
key_id = '810dbab847a0acee365a6c4760b37f213283700db2fc8df36f716878046be2a5'
AND (
token = 'jZmJWBbfcqL/t5uUA1r6hTYmu6ceYcuD5+yDO3OS9m0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)