UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QaXUp4gMmwq6bGy558gn8sPIpYY1hmGUDc5ma1Fedyc='
WHERE
key_id = 'dfea0ccd1873ab5214f9b4ac93bb42530ecc19bf9bfc6a9d8d2cebfb046969ea'
AND (
token = 'QaXUp4gMmwq6bGy558gn8sPIpYY1hmGUDc5ma1Fedyc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)