UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1mGuUVYZUYjfiYXTMUi9hfLB/TbN8uHGD9Mg/eESoOA='
WHERE
key_id = '3ae2325f93f740eab6dd7064417142deb0fd9335c014db9de6115aa04c73f41d'
AND (
token = '1mGuUVYZUYjfiYXTMUi9hfLB/TbN8uHGD9Mg/eESoOA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)