UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R/NVRN5Q5ezYDMXfm9w3BKT9uaXi65jmA6SfgHa+zgc='
WHERE
key_id = 'e7a733ced931f25f83c09acc31d639c66c4b7cd99769ecc335b6ac2cc09aa5ae'
AND (
token = 'R/NVRN5Q5ezYDMXfm9w3BKT9uaXi65jmA6SfgHa+zgc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)