UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TMEgBgHMAqIw+z+Kvsm39vusKX6N63wPhIGsuU1smJw='
WHERE
key_id = '027fe5172d765b1b0143832d9847c551ec2fd1f92a184cb64d48e80eeb9d1ffd'
AND (
token = 'TMEgBgHMAqIw+z+Kvsm39vusKX6N63wPhIGsuU1smJw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)