UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vHY3erQW9L18IyK0toVjRUkk0sfeAeFjx5nEFEHcwp4='
WHERE
key_id = '7b7d5197c78aac256343670d99001839405a86dc43456e192acfd42a325e8510'
AND (
token = 'vHY3erQW9L18IyK0toVjRUkk0sfeAeFjx5nEFEHcwp4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)