UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KgK8A6oKuDU+RJo8uV03x3QcMb7803OIh7MZuI9DKZ8='
WHERE
key_id = '17ab247104c36b454b246a121d9c0ed4163ac25a58c9e9fbe56849b3322fded1'
AND (
token = 'KgK8A6oKuDU+RJo8uV03x3QcMb7803OIh7MZuI9DKZ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)