UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QILxrvwJzQzktVc6Luvn+HinM3RKu6PQJflsVOdPtWI='
WHERE
key_id = 'd503301a1f45f863979f8a67b06f35604456f78e87e059787d34e63defb89318'
AND (
token = 'QILxrvwJzQzktVc6Luvn+HinM3RKu6PQJflsVOdPtWI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)