UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qnZBosEYLt5P+k5TOa5ElBYyrlja/VqSZLR4p/6Phxw='
WHERE
key_id = 'c4f6046df2d01b8851fc1ec5fbbc93ae19b101c4ffcef6f8a75313fbb1b86824'
AND (
token = 'qnZBosEYLt5P+k5TOa5ElBYyrlja/VqSZLR4p/6Phxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)