UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ipUP/pZNR45Efdji8gv3YCroBoYxtn1A0RRcHe29Tws='
WHERE
key_id = 'caa336f69dea461942a9bc86f64f68d33c7cc4ff81be9529ebc48fbac30053c2'
AND (
token = 'ipUP/pZNR45Efdji8gv3YCroBoYxtn1A0RRcHe29Tws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)