UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZKHYYx4X2/NfvcssGU9k4ahx97TMAMCy4ggvHTRvYCI='
WHERE
key_id = 'a4dabff4907e3ab8047054aa6adb9967773f0dab71abfa3a55f957f1ce46cf1d'
AND (
token = 'ZKHYYx4X2/NfvcssGU9k4ahx97TMAMCy4ggvHTRvYCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)