UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pkqSBizYO5NC2SZ1zaibJ+AR53fy+yPJgTD1LccCPKE='
WHERE
key_id = 'f3c56e4f15bdb0ec86726b32b7bcf85a70c76678bc431c2604e27ea504112815'
AND (
token = 'pkqSBizYO5NC2SZ1zaibJ+AR53fy+yPJgTD1LccCPKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)