UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HCCIq0mMo98bl1DkHI+oTaRzvVpM3U8cmXY155FtKM8='
WHERE
key_id = '24673882f64dbea0865f60410ab583b5242a50feec1df60399f1dde1ed26b0b0'
AND (
token = 'HCCIq0mMo98bl1DkHI+oTaRzvVpM3U8cmXY155FtKM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)