UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '78VZardH1hVXpfd5C5ZRwbrZrz5uNH56Sx+/IlZvSuI='
WHERE
key_id = '6b542e75b82ae49353c57537f824c1773ff648291cd75d290858039c5563c73e'
AND (
token = '78VZardH1hVXpfd5C5ZRwbrZrz5uNH56Sx+/IlZvSuI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)