UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZOX/8FQKJcThNp4sYAtTe0AiczZuM3quC8OF4jKRgQI='
WHERE
key_id = '494ed520306dc3d4d90aca3ddf3f911c7d27866b137210338451465339531e56'
AND (
token = 'ZOX/8FQKJcThNp4sYAtTe0AiczZuM3quC8OF4jKRgQI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)