UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZlKcDV6tYKmGg251+kLGZZjtUKqF43U5ONK9LVNZvUg='
WHERE
key_id = 'a03478978dc9dfb6c6f1dacd6be608f94526e8a85ec164da52020fbfb89703bd'
AND (
token = 'ZlKcDV6tYKmGg251+kLGZZjtUKqF43U5ONK9LVNZvUg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)