UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cMgF8m/naJ6AV4+M0zudM728qdCem9Irk23rkjyzolY='
WHERE
key_id = 'cad2c2f7d4eb0ae52a69a3192ed4b95e1c9866ce73e0326b9dc622b4041b09fb'
AND (
token = 'cMgF8m/naJ6AV4+M0zudM728qdCem9Irk23rkjyzolY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)