UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u5vBcnT4se3jGUIw07HHXpINIofDf/+eHb6PI0JbhOc='
WHERE
key_id = '7a6c3e16f13275176b1bb879fca9b5193ec17d341bceeff8ff202327e3fd4412'
AND (
token = 'u5vBcnT4se3jGUIw07HHXpINIofDf/+eHb6PI0JbhOc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)