UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gQlpG9LKu7DaSu0qfNnkJ3dG+sVK4dKbilGx9jsd1ts='
WHERE
key_id = 'bcf769b1dedc236e5096c995b06777b0b966a7d072daf0e072571ddcc723ea2c'
AND (
token = 'gQlpG9LKu7DaSu0qfNnkJ3dG+sVK4dKbilGx9jsd1ts='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)