UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PiD4Qxp4ynDtilMrN93S8ZT6bIayOJaX2yPBUwoxh6I='
WHERE
key_id = 'ca8e013b5de4b4cec51339f74c30c308672b28109f0a6b5bc7d39dbe2cde335a'
AND (
token = 'PiD4Qxp4ynDtilMrN93S8ZT6bIayOJaX2yPBUwoxh6I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)