UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nna7pwMZQGO99+b/pjeKBFgLcE7lvNzL405YYr1h/Mc='
WHERE
key_id = 'a911eb99340c939eb9589de42fc2f8a1d11a10cb65a802e105a582cd6a1a577c'
AND (
token = 'Nna7pwMZQGO99+b/pjeKBFgLcE7lvNzL405YYr1h/Mc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)