UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I2UKEE6YU65adrptToBedHN01uYcKnzX1Z1oo4s+FTw='
WHERE
key_id = 'd12947e443af39a2e36da7fc4fe8c6c8b7f65bef0813ba9a4b4e7e84cc103f55'
AND (
token = 'I2UKEE6YU65adrptToBedHN01uYcKnzX1Z1oo4s+FTw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)