UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V27QmOPOTkjeHKaejkjuAsp54GKxh7HHqwSyLUxqwhM='
WHERE
key_id = '7924dfd61301eb72cc4818cac1f81690c1318323b33842851e0512f3aee211ed'
AND (
token = 'V27QmOPOTkjeHKaejkjuAsp54GKxh7HHqwSyLUxqwhM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)