UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/Ol6A7gK2ERCgsLalR1B+8e4EcYJClU/hWAzRKFNg8M='
WHERE
key_id = '0fe557d49d51426c80602684e2787cad00aa4f9cb575bc971b53ac14439634c1'
AND (
token = '/Ol6A7gK2ERCgsLalR1B+8e4EcYJClU/hWAzRKFNg8M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)