UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4roHC6kFhfEiBLsjl8srX+gOGsHvRaafAhtT73MZXyM='
WHERE
key_id = '7c4e0a59448633198016fa1b4e16ca003aa2a6cc7b55b3a6e1705a676fcb4813'
AND (
token = '4roHC6kFhfEiBLsjl8srX+gOGsHvRaafAhtT73MZXyM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)