UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nV/+7sJdGyLa7vOepqHU7gGqm9V8IGf4sWhZGz0Kv0w='
WHERE
key_id = '3b737732dac5def2afbb88d5a3e23cb153e4a8e54157386575a18979bd9e9a19'
AND (
token = 'nV/+7sJdGyLa7vOepqHU7gGqm9V8IGf4sWhZGz0Kv0w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)