UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1a8HA50ejAMBFEgcWeidGYRkzBA9L2cdSi5i92CglIE='
WHERE
key_id = '6457c16a34e8e1c1bbd17ea79778d99da44d0c4e5fedf3eb7d972fcc103b3ef4'
AND (
token = '1a8HA50ejAMBFEgcWeidGYRkzBA9L2cdSi5i92CglIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)